﻿<html xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:mshelp="http://msdn.microsoft.com/mshelp" xmlns:mshelp="http://msdn.microsoft.com/mshelp" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:msxsl="urn:schemas-microsoft-com:xslt">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    
    <meta name="save" content="history" />
    <meta name="Language" content="en-us" />
    <meta name="Microsoft.Help.Id" content="ac299174-7f32-4867-8efb-c7bb50cdbd51" />
    <meta name="Description" content="You can use the Burndown report to help determine how much progress the team has made in completing work for an iteration or other interval of time. The report shows how many hours of work the team has completed and how many hours remain." />
    <meta name="Microsoft.Help.ContentType" content="Concepts" />
    <meta name="DCSext.ProductFamily" content="LIB_DG" />
    <meta name="DCSext.Product" content="ALM_TeamFoundation" />
    <meta name="DCSext.Title" value="Burndown Excel Report" />
    <link rel="stylesheet" type="text/css" href="../styles/presentation.css" />
    
    <script type="text/javascript" src="../scripts/EventUtilities.js"> </script>
    <script type="text/javascript" src="../scripts/SplitScreen.js"> </script>
    <script type="text/javascript" src="../scripts/Dropdown.js"> </script>
    <script type="text/javascript" src="../scripts/script_manifold.js"> </script>
    <script type="text/javascript" src="../scripts/script_feedBack.js"> </script>
    <script type="text/javascript" src="../scripts/CheckboxMenu.js"> </script>
    <script type="text/javascript" src="../scripts/CommonUtilities.js"> </script>
    <xml><MSHelp:TOCTitle Title="Burndown" /><MSHelp:Keyword Index="A" Term="ac299174-7f32-4867-8efb-c7bb50cdbd51" /><MSHelp:Attr Name="RevisionNumber" Value="15" /><MSHelp:Attr Name="AssetID" Value="ac299174-7f32-4867-8efb-c7bb50cdbd51" /><MSHelp:Attr Name="Abstract" Value="You can use the Burndown report to help determine how much progress the team has made in completing work for an iteration or other interval of time. The report shows how many hours of work the team has completed and how many hours remain. For informa ..." /><MSHelp:Attr Name="CommunityContent" Value="1" /><MSHelp:Attr Name="ShippedIn" Value="vs.90" /><MSHelp:Attr Name="TopicVersion" Value="10.0.10236.10000" /><MSHelp:Attr Name="Catalog Container" Value="System_Default_Catalog" /><MSHelp:Attr Name="Content Set Container" Value="System_Default_Content_Set" /><MSHelp:Attr Name="TopicType" Value="kbArticle" /><MSHelp:Attr Name="Locale" Value="en-us" /></xml>
    <title>Burndown Excel Report</title>
</head>
<body>
	<input type="hidden" id="userDataCache" class="userDataStyle" />
	<input type="hidden" id="hiddenScrollOffset" />
	<img id="collapseImage" style="display:none; height:0; width:0;" src="../icons/collapse_all.gif" alt="Collapse image" title="Collapse image" />
	<img id="expandImage" style="display:none; height:0; width:0;" src="../icons/expand_all.gif" alt="Expand Image" title="Expand Image" />
	<img id="collapseAllImage" style="display:none; height:0; width:0;" src="../icons/collapse_all.gif" />
	<img id="expandAllImage" style="display:none; height:0; width:0;" src="../icons/expand_all.gif" />
	<img id="dropDownImage" style="display:none; height:0; width:0;" src="../icons/dropdown.gif" />
	<img id="dropDownHoverImage" style="display:none; height:0; width:0;" src="../icons/dropdownHover.gif" />
	<img id="copyImage" style="display:none; height:0; width:0;" src="../icons/copycode.gif" alt="Copy image" title="Copy image" />
	<img id="copyHoverImage" style="display:none; height:0; width:0;" src="../icons/copycodeHighlight.gif" alt="CopyHover image" title="CopyHover image" />
	<div id="header">
		<table id="topTable" cellspacing="0" cellpadding="0">
			<tr>
				<td>
					<span onclick="ExpandCollapseAll(toggleAllImage)" style="cursor:default;" onkeypress="ExpandCollapseAll_CheckKey(toggleAllImage, event)" tabindex="0">
						<img ID="toggleAllImage" class="toggleAll" src="../icons/collapse_all.gif" /> 
						<label id="collapseAllLabel" for="toggleAllImage" style="display: none;">Collapse All</label>
						<label id="expandAllLabel" for="toggleAllImage" style="display: none;">Expand All</label> 
					</span> 
					<span>    </span> 
					<span id="devlangsDropdown" class="filter" tabindex="0">
						<img id="devlangsDropdownImage" src="../icons/dropdown.gif" /> 
						<label id="devlangsMenuAllLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: All </nobr></label>
						<label id="devlangsMenuMultipleLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: Multiple </nobr></label>
						<label id="devlangsMenuVisualBasicLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: Visual Basic </nobr></label>
						<label id="devlangsMenuCSharpLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: C# </nobr></label>
						<label id="devlangsMenuManagedCPlusPlusLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: Visual C++ </nobr></label>
						<label id="devlangsMenuFSharpLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: F# </nobr></label>
						<label id="devlangsMenuJScriptLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: JScript </nobr></label>
					</span> 
				</td>
			</tr>
		</table>
		<div id="devlangsMenu">
			<input id="VisualBasicCheckbox" type="checkbox" data="VisualBasic,vb,'persist'" value="on" onClick="SetLanguage(this)" />
			<label class="checkboxLabel" for="VisualBasicCheckbox">Visual Basic</label><br />
			<input id="CSharpCheckbox" type="checkbox" data="CSharp,cs,'persist'" value="on" onClick="SetLanguage(this)" />
			<label class="checkboxLabel" for="CSharpCheckbox">C#</label><br />
			<input id="ManagedCPlusPlusCheckbox" type="checkbox" data="ManagedCPlusPlus,cpp,'persist'" value="on" onClick="SetLanguage(this)" />
			<label class="checkboxLabel" for="ManagedCPlusPlusCheckbox">Visual C++</label><br />
			<input id="FSharpCheckbox" type="checkbox" data="FSharp,fs,'persist'" value="on" onClick="SetLanguage(this)" />
			<label class="checkboxLabel" for="FSharpCheckbox">F#</label><br />
			<input id="JScriptCheckbox" type="checkbox" data="JScript,cs,'persist'" value="on" onClick="SetLanguage(this)" />
			<label class="checkboxLabel" for="JScriptCheckbox">JScript</label><br />
		</div>
		<table id="bottomTable" cellpadding="0" cellspacing="0">
			<tr id="headerTableRow1">
				<td align="left">
					<span id="runningHeaderText"> </span> 
				</td>
			</tr>
			<tr id="headerTableRow2">
				<td align="left">
					<span id="nsrTitle">Burndown Excel Report</span> 
				</td>
			</tr>
			<tr id="headerTableRow3">
				<td align="left">
					<span id="headfeedbackarea" class="feedbackhead">
						<a href="javascript:SubmitFeedback('bjordan@microsoft.com','','','10.0','10.0.10236.10000','%0\dThank%20you%20for%20your%20feedback.%20The%20GovDev%20team%20uses%20your%20feedback%20to%20improve%20documentation.%20While%20we%20are%20reviewing%20your%20feedback,%20we%20may%20send%20you%20e-mail%20to%20ask%20for%20clarification%20or%20feedback%20on%20a%20solution.%20We%20do%20not%20use%20your%20e-mail%20address%20for%20any%20other%20purpose%20and%20we%20delete%20it%20after%20we%20finish%20our%20review.%0\AFor%20further%20information%20about%20the%20privacy%20policies%20of%20Microsoft,%20please%20see%20http://privacy.microsoft.com/en-us/default.aspx.%0\A%0\d','Customer%20Feedback');">
							Send Feedback
						</a>
					</span> 
				</td>
			</tr>
		</table>
		<table id="gradientTable">
			<tr>
				<td class="nsrBottom" background="../icons/gradient.gif" />
			</tr>
		</table>
	</div>
    <div id="mainSection">
        <div id="mainBody">
            <div id="allHistory" class="saveHistory" onsave="saveAll()" onload="loadAll()" />
            <font color="DarkGray"><p /></font>
            <div class="introduction">
                <p>You can use the Burndown report to help determine how much progress the team has
                    made in completing work for an iteration or other interval of time. The report shows
                    how many hours of work the team has completed and how many hours remain. For information
                    about how to access this report, see <span sdata="link"><a href="ExcelReportsGovDev.html">
                        Excel Reports (GovDev)</a></span>. </p>
                <div class="alert">
                    <table width="100%" cellspacing="0" cellpadding="0">
                        <tr>
                            <th align="left">
                                <img class="note" alt="Note" title="Note" src="../icons/alert_note.gif" /><b>Note
                                </b></th>
                        </tr>
                        <tr>
                            <td>
                                <p>You can view the Burndown report from the Progress dashboard. You can access this
                                    dashboard only if your team project portal has been enabled and is provisioned to
                                    use Microsoft Office SharePoint Server 2007. For more information, see <span sdata="link">
                                        <a href="http://msdn.microsoft.com/library/644ee4b7-3653-4943-9809-3d14d4d79c48">Access
                                            a Team Project Portal and Process Guidance</a></span>. </p>
                            </td>
                        </tr>
                    </table>
                </div>
                <div class="caption"></div>
                <div class="tableSection">
                    <table width="50%" cellspacing="2" cellpadding="5" frame="lhs">
                        <tr>
                            <th>
                                <p><span class="label">In this topic</span> </p>
                            </th>
                            <th>
                                <p><span class="label">Related topics</span> </p>
                            </th>
                        </tr>
                        <tr>
                            <td>
                                <ul>
                                    <li>
                                        <p><a href="#Data">Data in the Report</a></p>
                                    </li>
                                    <li>
                                        <p><a href="#RequiredActivities">Required Activites for Tracking Burndown</a></p>
                                    </li>
                                    <li>
                                        <p><a href="#Interpreting">Interpreting the Report</a></p>
                                    </li>
                                    <li>
                                        <p><a href="#Updating">Updating and Customizing the Report</a></p>
                                    </li>
                                </ul>
                            </td>
                            <td>
                                <ul>
                                    <li>
                                        <p><span sdata="link"><a href="ProgressDashboardGovDev.html">Progress Dashboard (GovDev)
                                            </a></span> </p>
                                    </li>
                                    <li>
                                        <p><span sdata="link"><a href="IterationBacklogWorkbook.html">Iteration Task Backlog Workbook
                                            </a></span> </p>
                                    </li>
                                    <li>
                                        <p><span sdata="link"><a href="BurndownandBurnRateReportGovDev.html">Burndown and Burn
                                            Rate Report (GovDev)</a></span> </p>
                                    </li>
                                </ul>
                            </td>
                        </tr>
                    </table>
                </div>
                <p><span class="label">Required Permissions</span> </p>
                <p>To view the report, you must be assigned or belong to a group that has been assigned
                    the <span class="ui">Read</span> permissions in SharePoint Products for the team
                    project. </p>
                <p>To modify or customize the report, you must be a member of the <span class="ui">TfsWarehouseDataReaders
                    </span> security role in SQL Server Analysis Services. You must also be assigned
                    or belong to a group that has been assigned the <span class="ui">Members</span> permissions
                    in SharePoint Products for the team project. For more information, see <span sdata="link">
                        <a href="http://msdn.microsoft.com/library/c7488754-77af-4fb4-8eca-1af0d206c9c8">Grant
                            Access to the Databases of the Data Warehouse for Visual Studio ALM</a></span> 
                    and <span sdata="link"><a href="http://msdn.microsoft.com/library/8f1f5f39-ed0f-4539-bee1-7e7e77bb5728">
                        Managing Permissions</a></span>. </p>
            </div>
            <a name="Data" />
            <h1 class="heading"><span onclick="ExpandCollapse(sectionToggle0)" style="cursor: default;"
                onkeypress="ExpandCollapse_CheckKey(sectionToggle0, event)" tabindex="0">
                <img id="sectionToggle0" class="toggle" name="toggleSwitch" src="../icons/collapse_all.gif" />Data
                in the Report</span> </h1>
            <div id="sectionSection0" class="section" name="collapseableSection" style="">
                <p>The Burndown report shows a stacked area chart of the <span class="ui">Completed
                    Work</span> and <span class="ui">Remaining Work</span> hours that have been tracked
                    for all Tasks during the time interval set for the report. The default interval
                    is the current week through the next three weeks. </p>
                <img alt="Burndown chart" src="../art/ProcGuid_AgileBurn.png" /><p>The <span class="ui">
                    Ideal Trend</span> line calculates a slope or trajectory for when the team will complete
                    work based on the amount of work that remains and the end date of the report. A
                    healthy Burndown chart shows that the team is making steady progress toward finishing
                    the work. The line is drawn from the remaining work on the start date and intersects
                    the x-axis on the end date.</p>
            </div>
            <a name="RequiredActivities" />
            <h1 class="heading"><span onclick="ExpandCollapse(sectionToggle1)" style="cursor: default;"
                onkeypress="ExpandCollapse_CheckKey(sectionToggle1, event)" tabindex="0">
                <img id="sectionToggle1" class="toggle" name="toggleSwitch" src="../icons/collapse_all.gif" />Required
                Activities for Tracking Burndown</span> </h1>
            <div id="sectionSection1" class="section" name="collapseableSection" style="">
                <p>For the Burndown chart to be useful and accurate, the team must perform the following
                    activities:</p>
                <ul>
                    <li>
                        <p>Define Tasks, and specify the <span class="ui">Iteration</span> and <span class="ui">
                            Area</span> paths for each. </p>
                    </li>
                    <li>
                        <p>Specify and update the <span class="ui">Completed</span> and <span class="ui">Remaining
                            </span> fields for each Task as the team works on it.</p>
                        <div class="alert">
                            <table width="100%" cellspacing="0" cellpadding="0">
                                <tr>
                                    <th align="left">
                                        <img class="note" alt="Important note" title="Important note" src="../icons/alert_caution.gif" /><b>Important
                                        </b></th>
                                </tr>
                                <tr>
                                    <td>
                                        <p>If you subdivide a Task into subtasks, specify hours only for the subtasks. These
                                            hours are rolled up as summary values for the parent task and use case. </p>
                                    </td>
                                </tr>
                            </table>
                        </div>
                    </li>
                </ul>
            </div>
            <a name="Interpreting" />
            <h1 class="heading"><span onclick="ExpandCollapse(sectionToggle2)" style="cursor: default;"
                onkeypress="ExpandCollapse_CheckKey(sectionToggle2, event)" tabindex="0">
                <img id="sectionToggle2" class="toggle" name="toggleSwitch" src="../icons/collapse_all.gif" />Interpreting
                the Report</span> </h1>
            <div id="sectionSection2" class="section" name="collapseableSection" style="">
                <p>You can review the Burndown report to determine the progress that the team made during
                    an iteration. For example, you can find answers to the following questions:</p>
                <ul>
                    <li>
                        <p>How fast is the team completing remaining work? </p>
                    </li>
                    <li>
                        <p>Is the team adding work during the iteration? Is the team allowing scope creep?
                        </p>
                    </li>
                    <li>
                        <p>How much work can the team complete in the available time?</p>
                    </li>
                    <li>
                        <p>When can the team finish the work?</p>
                    </li>
                    <li>
                        <p>When can the team finish the current iteration?</p>
                    </li>
                </ul>
            </div>
            <a name="Updating" />
            <h1 class="heading"><span onclick="ExpandCollapse(sectionToggle3)" style="cursor: default;"
                onkeypress="ExpandCollapse_CheckKey(sectionToggle3, event)" tabindex="0">
                <img id="sectionToggle3" class="toggle" name="toggleSwitch" src="../icons/collapse_all.gif" />Updating
                and Customizing the Report</span> </h1>
            <div id="sectionSection3" class="section" name="collapseableSection" style="">
                <p>You can update the Burndown report by opening the report in Office Excel and changing
                    the filter options for the PivotTable report or change the start date for the report.
                    You can customize this report to support other views as the following table describes.
                </p>
                <div class="caption"></div>
                <div class="tableSection">
                    <table width="50%" cellspacing="2" cellpadding="5" frame="lhs">
                        <tr>
                            <th>
                                <p>View</p>
                            </th>
                            <th>
                                <p>Action</p>
                            </th>
                        </tr>
                        <tr>
                            <td>
                                <p>Burndown for an iteration</p>
                            </td>
                            <td>
                                <p>Change the filter for <b>Iteration</b>(default=All)</p>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <p>Burndown for a product area</p>
                            </td>
                            <td>
                                <p>Change the filter for <b>Area</b>(default=All)</p>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <p>Burndown for a specific time interval</p>
                            </td>
                            <td>
                                <p>In the <span class="ui">Reports</span> worksheet, perform the following steps:
                                </p>
                                <ol>
                                    <li>
                                        <p>In the cell under <span class="ui">Date</span>, specify the start date of the time
                                            interval in either mm/dd or mm/dd/yyyy format.</p>
                                    </li>
                                    <li>
                                        <p>Click the cell that contains the start date that you just specified, and then drag
                                            the fill handle<img alt="A small square in the cell's lower-right corner." src="../art/Icon_FillHandle.gif" />
                                            across the cells that you want to fill.</p>
                                    </li>
                                    <li>
                                        <p>(Optional) Use the <span class="ui">Auto Fill Options</span> button
                                            <img alt="Auto Fill Options button image" src="../art/Icon_AutoFillOptions.gif" />
                                            to specify how to fill the selection. For example, you can specify <span class="ui">
                                                Fill Series</span> or <span class="ui">Fill Weekdays</span>. </p>
                                        <p>For more information, see the following page on the Microsoft Web site: <a href="http://go.microsoft.com/fwlink/?LinkID=165808">
                                            Fill data in worksheet cells</a>.</p>
                                    </li>
                                    <li>
                                        <p>On the <span class="ui">Data</span> tab, in the <span class="ui">Connections</span> 
                                            group, click <span class="ui">Refresh All.</span> </p>
                                    </li>
                                </ol>
                            </td>
                        </tr>
                    </table>
                </div>
                <p>For more information about how to work with and customize PivotTable and PivotChart
                    reports, see the following pages on the Microsoft Web site:</p>
                <ul>
                    <li>
                        <p><a href="http://go.microsoft.com/fwlink/?LinkId=165722">Ways to customize PivotTable
                            reports</a></p>
                    </li>
                    <li>
                        <p><a href="http://go.microsoft.com/fwlink/?LinkId=165723">Edit or remove a workbook
                            from Excel Services</a></p>
                    </li>
                    <li>
                        <p><a href="http://go.microsoft.com/fwlink/?LinkId=165724">Publish a workbook to Excel
                            Services</a></p>
                    </li>
                    <li>
                        <p><a href="http://go.microsoft.com/fwlink/?LinkId=165725">Save a file to a SharePoint
                            library or another Web location</a></p>
                    </li>
                </ul>
            </div>
            <h1 class="heading"><span onclick="ExpandCollapse(seeAlsoToggle)" style="cursor: default;"
                onkeypress="ExpandCollapse_CheckKey(seeAlsoToggle, event)" tabindex="0">
                <img id="seeAlsoToggle" class="toggle" name="toggleSwitch" src="../icons/collapse_all.gif" />See
                Also</span> </h1>
            <div id="seeAlsoSection" class="section" name="collapseableSection" style="">
                <h4 class="subHeading">Concepts</h4>
                <div class="seeAlsoStyle"><span sdata="link"><a href="ProgressDashboardGovDev.html">Progress
                    Dashboard (GovDev)</a></span> </div>
                <div class="seeAlsoStyle"><span sdata="link"><a href="TaskGovDev.html">Task (GovDev)
                    </a></span> </div>
                <div class="seeAlsoStyle"><span sdata="link"><a href="BurndownandBurnRateReportGovDev.html">
                    Burndown and Burn Rate Report (GovDev)</a></span> </div>
                <h4 class="subHeading">Other Resources</h4>
                <div class="seeAlsoStyle"><span sdata="link"><a href="ExcelReportsGovDev.html">Excel
                    Reports (GovDev)</a></span> </div>
            </div>
        </div>
        <div id="footer">
            <div class="footerLine">
                <img width="100%" height="3px" src="../icons/footer.gif" alt="Footer image" title="Footer image" />
            </div>
            <span id="feedbackarea">Send <a href="javascript:SubmitFeedback('bjordan@microsoft.com','','','10.0','10.0.10236.10000','%0\dThank%20you%20for%20your%20feedback.%20The%20GovDev%20team%20uses%20your%20feedback%20to%20improve%20documentation.%20While%20we%20are%20reviewing%20your%20feedback,%20we%20may%20send%20you%20e-mail%20to%20ask%20for%20clarification%20or%20feedback%20on%20a%20solution.%20We%20do%20not%20use%20your%20e-mail%20address%20for%20any%20other%20purpose%20and%20we%20delete%20it%20after%20we%20finish%20our%20review.%0\AFor%20further%20information%20about%20the%20privacy%20policies%20of%20Microsoft,%20please%20see%20http://privacy.microsoft.com/en-us/default.aspx.%0\A%0\d','Customer%20Feedback');">
                feedback </a>on this topic or submit an issue at the GovDev for TFS Codeplex Site.</span> 
        </div>
    </div>
</body>
</html>
